Computer Question Bank
for Exam preparation

Q2. Ms Excel:Which of the following is correct syntax in Excel?

1. =IF(LogicalTest, TrueResult, FalseResult)
2. =IF(LogicalTest, (TrueResult, FalseResult))
3. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
4. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Q3. System files allocated at

1. Boot area
2. FAT area
3. Data area
4. Directory

Q4. Ms Excel:Which of following is Not one of Excel’s what-if function?

1. Goal seek
2. Solver
3. Scenario manager
4. Auto Outline

Q5. Ms Access: This query wizard will create a select query.

1. Crosstab
2. Find duplicates
3. Simple
4. Design view

Q6. What is Thrashing?

1. A high paging activity is called thrashin
3. A high executing activity is called thrashing
4. A extremely long process is called thrashing
5. A extremely long virtual memory is called thrashing

Q7. Ms Access: In a query, what symbol is used to surround a parameter\’s user prompt?

1. [ ]
2. { }
3. ” ”
4. ( )

Q8. Ms Access: This is not one of the sections of the form design window

1. Form footer
2. Form content
3. Form header
4. Form detail

Q9. The virtual memory is

1. An extremely large main memory
2. An extremely large secondary memory
3. An illusion of extremely large main memory
4. A type of memory used in super computer

Q10. Ms Excel:A smart tag will be removed from a cell when

1. the cell is moved
2. the cell is hidden
3. the data in the cell is changed or deleted
4. the formatting of the cell is changed